﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OracleClient;


public partial class trangchu : System.Web.UI.Page
{
    private DataTable GetDataTable()
    {
        DataTable dt = DataConnection.GetDatatableByStoreProcedureNameNoParam("NGOCTRAN.get_sach_rs");
        return dt;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        DataConnection.str = @"Data Source=xe;User ID=NGOCTRAN;Password=12345";
        dlSach.DataSource = GetDataTable();
        dlSach.DataBind();

        clp1.MaxPages = 1000;
        clp1.PageSize = 8;
        clp1.DataSource = GetDataTable().DefaultView; ;
        clp1.BindToControl = dlSach;
        dlSach.DataSource = clp1.DataSourcePaged;
        dlSach.DataBind();
    }
}